package com.ysd.lis.entity.qi;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import com.ysd.lis.entity.BaseEntity;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.util.List;

/**
 * <p>
 * 指标项目条件表
 * </p>
 *
 * @author prs
 * @since 2024-07-04
 */
@Data
@EqualsAndHashCode(callSuper = true)
@TableName("QI_INDEX_SQL")
public class QiIndexSql extends BaseEntity {

    private static final long serialVersionUID = 1L;

    /**
     * 指标id
     */
    @TableField("INDEX_ID")
    private String indexId;

    /**
     * 指标报表编码
     */
    @TableField("INDEX_CODE")
    private String indexCode;


    /**
     * 项目id
     */
    @TableField("ITEM_ID")
    private String itemId;

    /**
     * 项目编码
     */
    @TableField("ITEM_CODE")
    private String itemCode;

    /**
     * 专业id
     */
    @TableField("MAJOR_ID")
    private String majorId;

    /**
     * 专业编码
     */
    @TableField("MAJOR_CODE")
    private String majorCode;

    /**
     * 数据源id
     */
    @TableField("QI_DATABASE_ID")
    private String qiDatabaseId;

    /**
     * SQL语句
     */
    @TableField("SQL_SENTENCE")
    private String sqlSentence;
    /**
     * DISTINCT_FLAG
     */
    @TableField("DISTINCT_FLAG")
    private Boolean distinctFlag;

    @TableField(exist = false)
    private List<QiIndexSqlTable> qiIndexSqlTableList;

    @TableField(exist = false)
    private List<QiIndexSqlSelect> qiIndexSqlSelectList;

    @TableField(exist = false)
    private List<QiIndexSqlWhere> qiIndexSqlWhereList;

    @TableField(exist = false)
    private List<QiIndexSqlWhere> qiIndexSqlSpecifyList;

    @TableField(exist = false)
    private List<QiIndexSqlExists> qiIndexSqlExistsList;

}
